﻿/*
{
"状态":1,
"名称":"获取-BI日期数据",
"作者":"马学兵",
"创建时间":"2019-02-19",
"功能":"获取-BI日期数据",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/
declare @sdate date='{sdate}'
declare @edate date='{edate}'

select dkey,dbo.FormatDateTime(keydate,'yyyy-MM-dd') as keydate,daytype,holidaytype,otherholidaytype,
dbo.FormatDateTime(comparisondate,'yyyy-MM-dd') as comparisondate ,coefficient,solarterms from  
EIDW.dbo.b_date where keydate>=@sdate and keydate<=@edate
order by dkey
